2015-06-09 - 19454.100 - BreakFix - INV330 Report changes #CrystalReportsSupport
BREAK FIX
19454.100 - INV330
Problem Summary
Need to make changes in INV330 report to include all blank materials and exclude future PO receipts.
Admin Info
Purpose
|
Need to make changes in INV330 report to include all blank materials and exclude future PO receipts.
|
Requested by
|
Jennifer Wolf
|
Issue Date
|
06-09-2015
|
Resolved by
|
Venkateswara Reddy D
|
Resolved Date
|
06-30-2015
|
Document Status
|
Complete
|
Detailed Problem Description
Logic in INV330 Main Report: Based on two CSV files:
CSV files
1. J_3ABDSI_APPAREL.csv – Generated by Datasource report “J_3ABDSI_Apparel”.
2. MCHB_APPAREL.csv - Generated by Datasource report “MCHB_Apparel”.
Datasource Reports
Datasource report “J_3ABDSI_Apparel” is based on the tables J_3ABDSI and MARC.
Datasource report “MCHB_Apparel” is based on the tables MAKT,MARC,MARD and MCHB.
Links(Left outer Join)
MCHB_APPAREL_csv.MATERIAL -> J_3ABDSI_APPAREL_csv.MATERIAL.
MCHB_APPAREL_csv.SIZE -> J_3ABDSI_APPAREL_csv.SIZE.
Logic in J_3ABDSI_Apparel Report:
Links(Inner join)
J_3ABDSI.MANDT -> MARC.MANDT.
J_3ABDSI.WERKS -> MARC.WERKS.
J_3ABDSI.MATNR -> MARC.MATNR.
Data Filters
{MARC.WERKS} in ["1410"] and
{MARC.DISGR} IN ["MBA", "PBA"] and
{MARC.DISPO} = '720' and
{J_3ABDSI.BDART} <> "PB" and
{J_3ABDSI.LFEAL} = "" and
{J_3ABDSI.LOEDK} = ""
Logic in MCHB_Apparel Report:
Links(Inner join)
MARC.MATNR -> MARD.MATNR
MARC.WERKS -> MARD.WERKS
MARC.MATNR -> MAKT.MATNR
MARD.LGORT -> MCHB.LGORT
MARD.WERKS -> MCHB.WERKS
MARD.MATNR -> MCHB.MATNR
Data Filters
{MARD.WERKS} in ["1410"] and
{MARC.DISGR} IN ["MBA", "PBA"] and
{MCHB.CLABS} <> 0.00 and
{MARC.DISPO} = '720'
Solution Analysis and Recommendations
1.
Need to update the existing table "J_3ABDS"I with "J_ADBBA" in the data source report(J_3ABDSI_Apparel).
2. Need to change the filter conditions in the data source report(J_3ABDSI_Apparel).
Resolution
1)
Need to update the existing table "J_3ABDS"I with "J_ADBBA" in the data source report(J_3ABDSI_Apparel).
2) Need to change the filter conditions in the data source report(J_3ABDSI_Apparel).
{MARC.DISPO} = "720" and
{J_3ABDSI.BDART} in ["", "PB", "SI", "SP"] and
{MARC.DISGR} in ["MBA", "PBA"] and
{MARC.WERKS} in ["1410"] and
{J_3ABDSI.J_3ABSKZ} = "C"
3) Need to update all formatting changes based on NEC standards.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
Release Information
None